Dataset statistics
| Number of variables | 49 |
|---|---|
| Number of observations | 49847 |
| Missing cells | 41116 |
| Missing cells (%) | 1.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 111.3 MiB |
| Average record size in memory | 2.3 KiB |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 23 |
| Boolean | 14 |
ANALYTES has constant value "B" | Constant |
HOUSE_NUM has a high cardinality: 1571 distinct values | High cardinality |
STREET_NAME has a high cardinality: 4107 distinct values | High cardinality |
CONFIRMATION_NUM has a high cardinality: 41010 distinct values | High cardinality |
INSPECTION_BY_FIRM has a high cardinality: 700 distinct values | High cardinality |
INSPECTION_DATE has a high cardinality: 3116 distinct values | High cardinality |
LAB_NAME has a high cardinality: 738 distinct values | High cardinality |
NTA has a high cardinality: 147 distinct values | High cardinality |
BIN is highly correlated with ZIP and 3 other fields | High correlation |
ZIP is highly correlated with BOROUGH and 6 other fields | High correlation |
BLOCK is highly correlated with BOROUGH and 7 other fields | High correlation |
LOT is highly correlated with ANALYTES | High correlation |
REPORTING_YEAR is highly correlated with BATCH_DATE | High correlation |
TANK_NUM is highly correlated with ANALYTES | High correlation |
LATITUDE is highly correlated with BOROUGH and 7 other fields | High correlation |
LONGITUDE is highly correlated with BOROUGH and 7 other fields | High correlation |
COMMUNITY_BOARD is highly correlated with BLOCK and 3 other fields | High correlation |
COUNCIL_DISTRICT is highly correlated with BOROUGH and 7 other fields | High correlation |
CENSUS_TRACT is highly correlated with ZIP and 4 other fields | High correlation |
BBL is highly correlated with BOROUGH and 8 other fields | High correlation |
BOROUGH is highly correlated with ZIP and 5 other fields | High correlation |
INSPECTION_PERFORMED is highly correlated with GI_REQ_INTERNAL_STRUCTURE and 9 other fields | High correlation |
GI_REQ_INTERNAL_STRUCTURE is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
GI_RESULT_INTERNAL_STRUCTURE is highly correlated with GI_RESULT_EXTERNAL_STRUCTURE and 3 other fields | High correlation |
GI_REQ_EXTERNAL_STRUCTURE is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
GI_RESULT_EXTERNAL_STRUCTURE is highly correlated with GI_RESULT_INTERNAL_STRUCTURE and 5 other fields | High correlation |
GI_REQ_OVERFLOW_PIPES is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
GI_RESULT_OVERFLOW_PIPES is highly correlated with GI_RESULT_EXTERNAL_STRUCTURE and 2 other fields | High correlation |
GI_REQ_ACCESS_LADDERS is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
GI_RESULT_ACCESS_LADDERS is highly correlated with GI_RESULT_INTERNAL_STRUCTURE and 4 other fields | High correlation |
GI_REQ_AIR_VENTS is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
GI_RESULT_AIR_VENTS is highly correlated with GI_RESULT_INTERNAL_STRUCTURE and 3 other fields | High correlation |
GI_REQ_ROOF_ACCESS is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
GI_RESULT_ROOF_ACCESS is highly correlated with GI_RESULT_EXTERNAL_STRUCTURE and 1 other fields | High correlation |
SI_REQ_SEDIMENT is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
SI_RESULT_SEDIMENT is highly correlated with SI_RESULT_DEBRIS_INSECTS | High correlation |
SI_REQ_BIOLOGICAL_GROWTH is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
SI_RESULT_BIOLOGICAL_GROWTH is highly correlated with SI_RESULT_DEBRIS_INSECTS and 1 other fields | High correlation |
SI_REQ_DEBRIS_INSECTS is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
SI_RESULT_DEBRIS_INSECTS is highly correlated with SI_RESULT_SEDIMENT and 1 other fields | High correlation |
SI_REQ_RODENT_BIRD is highly correlated with INSPECTION_PERFORMED and 9 other fields | High correlation |
SI_RESULT_RODENT_BIRD is highly correlated with SI_RESULT_BIOLOGICAL_GROWTH and 1 other fields | High correlation |
SAMPLE_COLLECTED is highly correlated with ECOLI and 4 other fields | High correlation |
NYS_CERTIFIED is highly correlated with MEET_STANDARDS | High correlation |
ANALYTES is highly correlated with ECOLI and 28 other fields | High correlation |
COLIFORM is highly correlated with ECOLI | High correlation |
ECOLI is highly correlated with COLIFORM and 1 other fields | High correlation |
MEET_STANDARDS is highly correlated with GI_RESULT_INTERNAL_STRUCTURE and 5 other fields | High correlation |
DELETED is highly correlated with MEET_STANDARDS and 3 other fields | High correlation |
BATCH_DATE is highly correlated with REPORTING_YEAR | High correlation |
MEET_STANDARDS has 38723 (77.7%) missing values | Missing |
BIN is highly skewed (γ1 = 32.81932176) | Skewed |
CONFIRMATION_NUM is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2024-05-07 19:20:48.568146 |
|---|---|
| Analysis finished | 2024-05-07 19:21:48.177178 |
| Duration | 59.61 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 5559 |
|---|---|
| Distinct (%) | 11.2% |
| Missing | 112 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4251135.238 |
| Minimum | 1000000 |
|---|---|
| Maximum | 4050200001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 1000000 |
|---|---|
| 5-th percentile | 1002348 |
| Q1 | 1020194 |
| median | 1041701 |
| Q3 | 1082759 |
| 95-th percentile | 3348849 |
| Maximum | 4050200001 |
| Range | 4049200001 |
| Interquartile range (IQR) | 62565 |
Descriptive statistics
| Standard deviation | 66882052.86 |
|---|---|
| Coefficient of variation (CV) | 15.73275116 |
| Kurtosis | 1433.246056 |
| Mean | 4251135.238 |
| Median Absolute Deviation (MAD) | 26118 |
| Skewness | 32.81932176 |
| Sum | 2.114302111 × 1011 |
| Variance | 4.473208994 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1084781 | 115 | 0.2% |
| 1083346 | 100 | 0.2% |
| 1071414 | 90 | 0.2% |
| 1026318 | 80 | 0.2% |
| 1001394 | 79 | 0.2% |
| 1015862 | 71 | 0.1% |
| 1001227 | 70 | 0.1% |
| 1001025 | 69 | 0.1% |
| 1000000 | 68 | 0.1% |
| 1085735 | 59 | 0.1% |
| Other values (5549) | 48934 | |
| (Missing) | 112 | 0.2% |
| Value | Count | Frequency (%) |
| 1000000 | 68 | |
| 1000005 | 32 | |
| 1000006 | 22 | < 0.1% |
| 1000007 | 16 | < 0.1% |
| 1000018 | 9 | < 0.1% |
| 1000020 | 19 | < 0.1% |
| 1000021 | 30 | |
| 1000023 | 9 | < 0.1% |
| 1000025 | 21 | < 0.1% |
| 1000027 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 4050200001 | 1 | |
| 4020860040 | 1 | |
| 4002680001 | 1 | |
| 3065080006 | 1 | |
| 3036210001 | 1 | |
| 3019020001 | 1 | |
| 3012830001 | 1 | |
| 3010720040 | 1 | |
| 3001220010 | 1 | |
| 2043470007 | 1 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.1 MiB |
| MANHATTAN | |
|---|---|
| BROOKLYN | 2925 |
| BRONX | 2291 |
| QUEENS | 1962 |
| STATEN ISLAND | 76 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 8.645495215 |
| Min length | 5 |
Characters and Unicode
| Total characters | 430952 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MANHATTAN |
|---|---|
| 2nd row | MANHATTAN |
| 3rd row | BRONX |
| 4th row | MANHATTAN |
| 5th row | QUEENS |
Common Values
| Value | Count | Frequency (%) |
| MANHATTAN | 42593 | |
| BROOKLYN | 2925 | 5.9% |
| BRONX | 2291 | 4.6% |
| QUEENS | 1962 | 3.9% |
| STATEN ISLAND | 76 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| manhattan | 42593 | |
| brooklyn | 2925 | 5.9% |
| bronx | 2291 | 4.6% |
| queens | 1962 | 3.9% |
| staten | 76 | 0.2% |
| island | 76 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 127931 | |
| N | 92516 | |
| T | 85338 | |
| M | 42593 | 9.9% |
| H | 42593 | 9.9% |
| O | 8141 | 1.9% |
| B | 5216 | 1.2% |
| R | 5216 | 1.2% |
| E | 4000 | 0.9% |
| L | 3001 | 0.7% |
| Other values (9) | 14407 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 430876 | |
| Space Separator | 76 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 127931 | |
| N | 92516 | |
| T | 85338 | |
| M | 42593 | 9.9% |
| H | 42593 | 9.9% |
| O | 8141 | 1.9% |
| B | 5216 | 1.2% |
| R | 5216 | 1.2% |
| E | 4000 | 0.9% |
| L | 3001 | 0.7% |
| Other values (8) | 14331 | 3.3% |
Space Separator
| Value | Count | Frequency (%) |
| 76 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 430876 | |
| Common | 76 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 127931 | |
| N | 92516 | |
| T | 85338 | |
| M | 42593 | 9.9% |
| H | 42593 | 9.9% |
| O | 8141 | 1.9% |
| B | 5216 | 1.2% |
| R | 5216 | 1.2% |
| E | 4000 | 0.9% |
| L | 3001 | 0.7% |
| Other values (8) | 14331 | 3.3% |
Common
| Value | Count | Frequency (%) |
| 76 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 430952 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 127931 | |
| N | 92516 | |
| T | 85338 | |
| M | 42593 | 9.9% |
| H | 42593 | 9.9% |
| O | 8141 | 1.9% |
| B | 5216 | 1.2% |
| R | 5216 | 1.2% |
| E | 4000 | 0.9% |
| L | 3001 | 0.7% |
| Other values (9) | 14407 | 3.3% |
| Distinct | 177 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 71 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10170.86674 |
| Minimum | 10001 |
|---|---|
| Maximum | 11694 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 10001 |
|---|---|
| 5-th percentile | 10002 |
| Q1 | 10016 |
| median | 10022 |
| Q3 | 10065 |
| 95-th percentile | 11217 |
| Maximum | 11694 |
| Range | 1693 |
| Interquartile range (IQR) | 49 |
Descriptive statistics
| Standard deviation | 373.8736833 |
|---|---|
| Coefficient of variation (CV) | 0.03675927457 |
| Kurtosis | 4.615142951 |
| Mean | 10170.86674 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 2.479114903 |
| Sum | 506265063 |
| Variance | 139781.531 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10022 | 2919 | 5.9% |
| 10016 | 2713 | 5.4% |
| 10019 | 2237 | 4.5% |
| 10001 | 2147 | 4.3% |
| 10017 | 1994 | 4.0% |
| 10024 | 1971 | 4.0% |
| 10003 | 1911 | 3.8% |
| 10036 | 1888 | 3.8% |
| 10025 | 1863 | 3.7% |
| 10023 | 1834 | 3.7% |
| Other values (167) | 28299 |
| Value | Count | Frequency (%) |
| 10001 | 2147 | |
| 10002 | 411 | 0.8% |
| 10003 | 1911 | |
| 10004 | 589 | 1.2% |
| 10005 | 517 | 1.0% |
| 10006 | 279 | 0.6% |
| 10007 | 746 | 1.5% |
| 10009 | 174 | 0.3% |
| 10010 | 1453 | |
| 10011 | 1623 |
| Value | Count | Frequency (%) |
| 11694 | 26 | 0.1% |
| 11692 | 23 | < 0.1% |
| 11691 | 55 | 0.1% |
| 11435 | 20 | < 0.1% |
| 11434 | 36 | 0.1% |
| 11433 | 13 | < 0.1% |
| 11432 | 175 | |
| 11421 | 6 | < 0.1% |
| 11418 | 25 | 0.1% |
| 11415 | 53 | 0.1% |
| Distinct | 1571 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| 1 | 791 |
|---|---|
| 200 | 666 |
| 10 | 515 |
| 300 | 437 |
| 50 | 420 |
| Other values (1566) |
Length
| Max length | 9 |
|---|---|
| Median length | 3 |
| Mean length | 2.918951993 |
| Min length | 1 |
Characters and Unicode
| Total characters | 145501 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 96 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 405 |
|---|---|
| 2nd row | 131 |
| 3rd row | 1118 |
| 4th row | 28 |
| 5th row | 30-30 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 791 | 1.6% |
| 200 | 666 | 1.3% |
| 10 | 515 | 1.0% |
| 300 | 437 | 0.9% |
| 50 | 420 | 0.8% |
| 40 | 409 | 0.8% |
| 55 | 389 | 0.8% |
| 150 | 383 | 0.8% |
| 2 | 372 | 0.7% |
| 30 | 369 | 0.7% |
| Other values (1561) | 45096 |
Length
| Value | Count | Frequency (%) |
| 1 | 791 | 1.6% |
| 200 | 666 | 1.3% |
| 10 | 515 | 1.0% |
| 300 | 437 | 0.9% |
| 50 | 420 | 0.8% |
| 40 | 409 | 0.8% |
| 55 | 389 | 0.8% |
| 150 | 383 | 0.8% |
| 2 | 372 | 0.7% |
| 30 | 369 | 0.7% |
| Other values (1558) | 45096 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 26537 | |
| 0 | 23184 | |
| 5 | 19414 | |
| 2 | 18048 | |
| 3 | 15185 | |
| 4 | 12770 | |
| 6 | 8462 | 5.8% |
| 7 | 7400 | 5.1% |
| 9 | 6065 | 4.2% |
| 8 | 6024 | 4.1% |
| Other values (19) | 2412 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 143089 | |
| Dash Punctuation | 2282 | 1.6% |
| Lowercase Letter | 72 | < 0.1% |
| Uppercase Letter | 58 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 26537 | |
| 0 | 23184 | |
| 5 | 19414 | |
| 2 | 18048 | |
| 3 | 15185 | |
| 4 | 12770 | |
| 6 | 8462 | 5.9% |
| 7 | 7400 | 5.2% |
| 9 | 6065 | 4.2% |
| 8 | 6024 | 4.2% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 21 | |
| n | 12 | |
| a | 9 | |
| s | 9 | |
| t | 9 | |
| w | 7 | 9.7% |
| i | 2 | 2.8% |
| r | 2 | 2.8% |
| b | 1 | 1.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 16 | |
| O | 13 | |
| S | 10 | |
| B | 5 | 8.6% |
| D | 4 | 6.9% |
| P | 3 | 5.2% |
| E | 3 | 5.2% |
| W | 3 | 5.2% |
| N | 1 | 1.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2282 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 145371 | |
| Latin | 130 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 21 | |
| A | 16 | |
| O | 13 | |
| n | 12 | |
| S | 10 | |
| a | 9 | |
| s | 9 | |
| t | 9 | |
| w | 7 | 5.4% |
| B | 5 | 3.8% |
| Other values (8) | 19 |
Common
| Value | Count | Frequency (%) |
| 1 | 26537 | |
| 0 | 23184 | |
| 5 | 19414 | |
| 2 | 18048 | |
| 3 | 15185 | |
| 4 | 12770 | |
| 6 | 8462 | 5.8% |
| 7 | 7400 | 5.1% |
| 9 | 6065 | 4.2% |
| 8 | 6024 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 145501 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 26537 | |
| 0 | 23184 | |
| 5 | 19414 | |
| 2 | 18048 | |
| 3 | 15185 | |
| 4 | 12770 | |
| 6 | 8462 | 5.8% |
| 7 | 7400 | 5.1% |
| 9 | 6065 | 4.2% |
| 8 | 6024 | 4.1% |
| Other values (19) | 2412 | 1.7% |
| Distinct | 4107 |
|---|---|
| Distinct (%) | 8.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| Broadway | 1389 |
|---|---|
| PARK AVENUE | 942 |
| Park Avenue | 905 |
| Fifth Avenue | 866 |
| BROADWAY | 730 |
| Other values (4102) |
Length
| Max length | 28 |
|---|---|
| Median length | 26 |
| Mean length | 13.76594379 |
| Min length | 4 |
Characters and Unicode
| Total characters | 686191 |
|---|---|
| Distinct characters | 68 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1057 ? |
|---|---|
| Unique (%) | 2.1% |
Sample
| 1st row | LEXINGTON AVE |
|---|---|
| 2nd row | East 66th Street |
| 3rd row | grand concourse |
| 4th row | EAST 10 STREET |
| 5th row | 47th Avenue |
Common Values
| Value | Count | Frequency (%) |
| Broadway | 1389 | 2.8% |
| PARK AVENUE | 942 | 1.9% |
| Park Avenue | 905 | 1.8% |
| Fifth Avenue | 866 | 1.7% |
| BROADWAY | 730 | 1.5% |
| Madison Avenue | 532 | 1.1% |
| WEST END AVENUE | 471 | 0.9% |
| West End Avenue | 471 | 0.9% |
| 5 AVENUE | 454 | 0.9% |
| FIFTH AVENUE | 379 | 0.8% |
| Other values (4097) | 42708 |
Length
| Value | Count | Frequency (%) |
| street | 24782 | |
| avenue | 12199 | 9.8% |
| west | 12082 | 9.8% |
| east | 10421 | 8.4% |
| park | 3389 | 2.7% |
| ave | 2356 | 1.9% |
| st | 2288 | 1.8% |
| broadway | 2179 | 1.8% |
| fifth | 1549 | 1.3% |
| end | 1310 | 1.1% |
| Other values (1136) | 51297 |
Most occurring characters
| Value | Count | Frequency (%) |
| 83157 | 12.1% | |
| e | 61299 | 8.9% |
| t | 58805 | 8.6% |
| E | 57077 | 8.3% |
| S | 41256 | 6.0% |
| T | 37915 | 5.5% |
| A | 27948 | 4.1% |
| r | 26045 | 3.8% |
| R | 19477 | 2.8% |
| a | 19317 | 2.8% |
| Other values (58) | 253895 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 279606 | |
| Uppercase Letter | 273957 | |
| Space Separator | 83157 | 12.1% |
| Decimal Number | 49129 | 7.2% |
| Other Punctuation | 331 | < 0.1% |
| Dash Punctuation | 11 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 61299 | |
| t | 58805 | |
| r | 26045 | |
| a | 19317 | 6.9% |
| s | 18538 | 6.6% |
| n | 16142 | 5.8% |
| h | 12990 | 4.6% |
| v | 10630 | 3.8% |
| u | 9599 | 3.4% |
| d | 8406 | 3.0% |
| Other values (16) | 37835 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 57077 | |
| S | 41256 | |
| T | 37915 | |
| A | 27948 | |
| R | 19477 | 7.1% |
| W | 15030 | 5.5% |
| N | 10687 | 3.9% |
| V | 7658 | 2.8% |
| U | 7241 | 2.6% |
| P | 5984 | 2.2% |
| Other values (16) | 43684 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 6237 | |
| 7 | 6134 | |
| 1 | 5549 | |
| 3 | 5515 | |
| 2 | 5345 | |
| 6 | 5043 | |
| 4 | 4942 | |
| 8 | 4495 | |
| 9 | 3440 | |
| 0 | 2429 | 4.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 324 | |
| , | 4 | 1.2% |
| \ | 2 | 0.6% |
| ' | 1 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 83157 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 11 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 553563 | |
| Common | 132628 | 19.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 61299 | 11.1% |
| t | 58805 | 10.6% |
| E | 57077 | 10.3% |
| S | 41256 | 7.5% |
| T | 37915 | 6.8% |
| A | 27948 | 5.0% |
| r | 26045 | 4.7% |
| R | 19477 | 3.5% |
| a | 19317 | 3.5% |
| s | 18538 | 3.3% |
| Other values (42) | 185886 |
Common
| Value | Count | Frequency (%) |
| 83157 | ||
| 5 | 6237 | 4.7% |
| 7 | 6134 | 4.6% |
| 1 | 5549 | 4.2% |
| 3 | 5515 | 4.2% |
| 2 | 5345 | 4.0% |
| 6 | 5043 | 3.8% |
| 4 | 4942 | 3.7% |
| 8 | 4495 | 3.4% |
| 9 | 3440 | 2.6% |
| Other values (6) | 2771 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 686191 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 83157 | 12.1% | |
| e | 61299 | 8.9% |
| t | 58805 | 8.6% |
| E | 57077 | 8.3% |
| S | 41256 | 6.0% |
| T | 37915 | 5.5% |
| A | 27948 | 4.1% |
| r | 26045 | 3.8% |
| R | 19477 | 2.8% |
| a | 19317 | 2.8% |
| Other values (58) | 253895 |
| Distinct | 1750 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1421.629266 |
| Minimum | 0 |
|---|---|
| Maximum | 20008 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 76 |
| Q1 | 825 |
| median | 1215 |
| Q3 | 1483 |
| 95-th percentile | 3943 |
| Maximum | 20008 |
| Range | 20008 |
| Interquartile range (IQR) | 658 |
Descriptive statistics
| Standard deviation | 1478.282916 |
|---|---|
| Coefficient of variation (CV) | 1.039851213 |
| Kurtosis | 28.86119515 |
| Mean | 1421.629266 |
| Median Absolute Deviation (MAD) | 352 |
| Skewness | 4.454009872 |
| Sum | 70863954 |
| Variance | 2185320.38 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 328 | 0.7% |
| 1293 | 169 | 0.3% |
| 838 | 166 | 0.3% |
| 1261 | 164 | 0.3% |
| 1263 | 157 | 0.3% |
| 1171 | 142 | 0.3% |
| 1290 | 142 | 0.3% |
| 1289 | 136 | 0.3% |
| 1480 | 136 | 0.3% |
| 833 | 132 | 0.3% |
| Other values (1740) | 48175 |
| Value | Count | Frequency (%) |
| 0 | 10 | < 0.1% |
| 1 | 11 | < 0.1% |
| 2 | 8 | < 0.1% |
| 4 | 32 | |
| 5 | 38 | |
| 6 | 26 | |
| 8 | 4 | < 0.1% |
| 9 | 58 | |
| 10 | 44 | |
| 11 | 40 |
| Value | Count | Frequency (%) |
| 20008 | 1 | < 0.1% |
| 16177 | 26 | |
| 16083 | 9 | < 0.1% |
| 16001 | 14 | < 0.1% |
| 15955 | 18 | |
| 15810 | 17 | |
| 15638 | 13 | < 0.1% |
| 15610 | 5 | < 0.1% |
| 15537 | 2 | < 0.1% |
| 12495 | 36 |
| Distinct | 235 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1342.518085 |
| Minimum | 0 |
|---|---|
| Maximum | 9999 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 10 |
| median | 31 |
| Q3 | 67 |
| 95-th percentile | 7502 |
| Maximum | 9999 |
| Range | 9999 |
| Interquartile range (IQR) | 57 |
Descriptive statistics
| Standard deviation | 2847.860064 |
|---|---|
| Coefficient of variation (CV) | 2.121282458 |
| Kurtosis | 0.9580028125 |
| Mean | 1342.518085 |
| Median Absolute Deviation (MAD) | 26 |
| Skewness | 1.716657115 |
| Sum | 66920499 |
| Variance | 8110306.945 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 8150 | 16.4% |
| 7501 | 5104 | 10.2% |
| 7502 | 2031 | 4.1% |
| 29 | 1004 | 2.0% |
| 33 | 851 | 1.7% |
| 20 | 847 | 1.7% |
| 7503 | 801 | 1.6% |
| 21 | 774 | 1.6% |
| 5 | 774 | 1.6% |
| 23 | 742 | 1.5% |
| Other values (225) | 28769 |
| Value | Count | Frequency (%) |
| 0 | 10 | < 0.1% |
| 1 | 8150 | |
| 2 | 415 | 0.8% |
| 3 | 425 | 0.9% |
| 4 | 351 | 0.7% |
| 5 | 774 | 1.6% |
| 6 | 471 | 0.9% |
| 7 | 606 | 1.2% |
| 8 | 547 | 1.1% |
| 9 | 490 | 1.0% |
| Value | Count | Frequency (%) |
| 9999 | 1 | < 0.1% |
| 9100 | 10 | |
| 9080 | 6 | |
| 9078 | 9 | |
| 9062 | 2 | < 0.1% |
| 9059 | 8 | |
| 9029 | 3 | < 0.1% |
| 9024 | 8 | |
| 9021 | 7 | |
| 9020 | 9 |
| Distinct | 41010 |
|---|---|
| Distinct (%) | 82.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.3 MiB |
| WTI4549961683 | 13 |
|---|---|
| WTI2501915939 | 13 |
| WTI0972981393 | 13 |
| WTI4421642046 | 13 |
| WTI3032892368 | 13 |
| Other values (41005) |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Characters and Unicode
| Total characters | 648011 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 35150 ? |
|---|---|
| Unique (%) | 70.5% |
Sample
| 1st row | WTI0794137521 |
|---|---|
| 2nd row | WTI9605598636 |
| 3rd row | WTI2761355464 |
| 4th row | WTI5921313699 |
| 5th row | WTI5300059568 |
Common Values
| Value | Count | Frequency (%) |
| WTI4549961683 | 13 | < 0.1% |
| WTI2501915939 | 13 | < 0.1% |
| WTI0972981393 | 13 | < 0.1% |
| WTI4421642046 | 13 | < 0.1% |
| WTI3032892368 | 13 | < 0.1% |
| WTI8800012013 | 13 | < 0.1% |
| WTI0949972830 | 13 | < 0.1% |
| WTI8513845933 | 13 | < 0.1% |
| WTI0312687900 | 13 | < 0.1% |
| WTI3785983490 | 13 | < 0.1% |
| Other values (41000) | 49717 |
Length
| Value | Count | Frequency (%) |
| wti4549961683 | 13 | < 0.1% |
| wti8513845933 | 13 | < 0.1% |
| wti2501915939 | 13 | < 0.1% |
| wti9332381256 | 13 | < 0.1% |
| wti3785983490 | 13 | < 0.1% |
| wti0312687900 | 13 | < 0.1% |
| wti1503958526 | 13 | < 0.1% |
| wti0949972830 | 13 | < 0.1% |
| wti8800012013 | 13 | < 0.1% |
| wti3032892368 | 13 | < 0.1% |
| Other values (41000) | 49717 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 50262 | 7.8% |
| 9 | 50196 | 7.7% |
| 6 | 50140 | 7.7% |
| 2 | 49993 | 7.7% |
| 8 | 49878 | 7.7% |
| 4 | 49875 | 7.7% |
| W | 49847 | 7.7% |
| T | 49847 | 7.7% |
| I | 49847 | 7.7% |
| 1 | 49805 | 7.7% |
| Other values (3) | 148321 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 498470 | |
| Uppercase Letter | 149541 | 23.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 50262 | |
| 9 | 50196 | |
| 6 | 50140 | |
| 2 | 49993 | |
| 8 | 49878 | |
| 4 | 49875 | |
| 1 | 49805 | |
| 7 | 49622 | |
| 5 | 49433 | |
| 0 | 49266 |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 49847 | |
| T | 49847 | |
| I | 49847 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 498470 | |
| Latin | 149541 | 23.1% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 50262 | |
| 9 | 50196 | |
| 6 | 50140 | |
| 2 | 49993 | |
| 8 | 49878 | |
| 4 | 49875 | |
| 1 | 49805 | |
| 7 | 49622 | |
| 5 | 49433 | |
| 0 | 49266 |
Latin
| Value | Count | Frequency (%) |
| W | 49847 | |
| T | 49847 | |
| I | 49847 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 648011 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 50262 | 7.8% |
| 9 | 50196 | 7.7% |
| 6 | 50140 | 7.7% |
| 2 | 49993 | 7.7% |
| 8 | 49878 | 7.7% |
| 4 | 49875 | 7.7% |
| W | 49847 | 7.7% |
| T | 49847 | 7.7% |
| I | 49847 | 7.7% |
| 1 | 49805 | 7.7% |
| Other values (3) | 148321 |
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2019.294321 |
| Minimum | 2000 |
|---|---|
| Maximum | 2024 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 2000 |
|---|---|
| 5-th percentile | 2015 |
| Q1 | 2017 |
| median | 2019 |
| Q3 | 2021 |
| 95-th percentile | 2023 |
| Maximum | 2024 |
| Range | 24 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.546163373 |
|---|---|
| Coefficient of variation (CV) | 0.001260917414 |
| Kurtosis | -0.9346836283 |
| Mean | 2019.294321 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.1619628901 |
| Sum | 100655764 |
| Variance | 6.482947923 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2020 | 6503 | |
| 2023 | 6012 | |
| 2022 | 5974 | |
| 2021 | 5887 | |
| 2019 | 5804 | |
| 2018 | 5541 | |
| 2017 | 4683 | |
| 2015 | 4584 | |
| 2016 | 4545 | |
| 2024 | 292 | 0.6% |
| Other values (3) | 22 | < 0.1% |
| Value | Count | Frequency (%) |
| 2000 | 3 | < 0.1% |
| 2011 | 2 | < 0.1% |
| 2014 | 17 | < 0.1% |
| 2015 | 4584 | |
| 2016 | 4545 | |
| 2017 | 4683 | |
| 2018 | 5541 | |
| 2019 | 5804 | |
| 2020 | 6503 | |
| 2021 | 5887 |
| Value | Count | Frequency (%) |
| 2024 | 292 | 0.6% |
| 2023 | 6012 | |
| 2022 | 5974 | |
| 2021 | 5887 | |
| 2020 | 6503 | |
| 2019 | 5804 | |
| 2018 | 5541 | |
| 2017 | 4683 | |
| 2016 | 4545 | |
| 2015 | 4584 |
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.304371376 |
| Minimum | 1 |
|---|---|
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 13 |
| Range | 12 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.8898090643 |
|---|---|
| Coefficient of variation (CV) | 0.6821746324 |
| Kurtosis | 37.62938186 |
| Mean | 1.304371376 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.14079338 |
| Sum | 65019 |
| Variance | 0.7917601709 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 41010 | |
| 2 | 5860 | 11.8% |
| 3 | 1528 | 3.1% |
| 4 | 720 | 1.4% |
| 5 | 267 | 0.5% |
| 6 | 178 | 0.4% |
| 7 | 104 | 0.2% |
| 8 | 70 | 0.1% |
| 9 | 41 | 0.1% |
| 10 | 31 | 0.1% |
| Other values (3) | 38 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 41010 | |
| 2 | 5860 | 11.8% |
| 3 | 1528 | 3.1% |
| 4 | 720 | 1.4% |
| 5 | 267 | 0.5% |
| 6 | 178 | 0.4% |
| 7 | 104 | 0.2% |
| 8 | 70 | 0.1% |
| 9 | 41 | 0.1% |
| 10 | 31 | 0.1% |
| Value | Count | Frequency (%) |
| 13 | 12 | < 0.1% |
| 12 | 13 | < 0.1% |
| 11 | 13 | < 0.1% |
| 10 | 31 | 0.1% |
| 9 | 41 | 0.1% |
| 8 | 70 | 0.1% |
| 7 | 104 | 0.2% |
| 6 | 178 | 0.4% |
| 5 | 267 | 0.5% |
| 4 | 720 |
| Distinct | 700 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 22 |
| Missing (%) | < 0.1% |
| Memory size | 3.6 MiB |
| Rosenwach Tank Co. LLC | |
|---|---|
| ISSEKS BROS INC | |
| American Pipe and Tank | |
| Isseks Bros. Inc. | 1764 |
| isseks bros., inc. | 1246 |
| Other values (695) |
Length
| Max length | 69 |
|---|---|
| Median length | 22 |
| Mean length | 19.09890617 |
| Min length | 1 |
Characters and Unicode
| Total characters | 951603 |
|---|---|
| Distinct characters | 69 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 321 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | ISSEKS BROS INC |
|---|---|
| 2nd row | Rosenwach Tank Co. LLC |
| 3rd row | DCAS |
| 4th row | ISSEKS BROS INC |
| 5th row | Rosenwach Tank Co. LLC |
Common Values
| Value | Count | Frequency (%) |
| Rosenwach Tank Co. LLC | 21887 | |
| ISSEKS BROS INC | 8139 | 16.3% |
| American Pipe and Tank | 4010 | 8.0% |
| Isseks Bros. Inc. | 1764 | 3.5% |
| isseks bros., inc. | 1246 | 2.5% |
| ISSEKS BROS., INC. | 1028 | 2.1% |
| Isseks Bros Inc | 935 | 1.9% |
| Isseks | 834 | 1.7% |
| Atlantank, LLC | 742 | 1.5% |
| Nalco | 725 | 1.5% |
| Other values (690) | 8515 | 17.1% |
Length
| Value | Count | Frequency (%) |
| tank | 28052 | |
| llc | 22969 | |
| co | 22163 | |
| rosenwach | 22002 | |
| isseks | 15781 | |
| inc | 15651 | |
| bros | 14673 | |
| american | 5962 | 3.5% |
| pipe | 5946 | 3.5% |
| and | 4524 | 2.6% |
| Other values (375) | 14179 |
Most occurring characters
| Value | Count | Frequency (%) |
| 122149 | 12.8% | |
| n | 73678 | 7.7% |
| a | 68481 | 7.2% |
| C | 57938 | 6.1% |
| o | 54592 | 5.7% |
| s | 47002 | 4.9% |
| L | 46723 | 4.9% |
| e | 42537 | 4.5% |
| S | 39039 | 4.1% |
| c | 35610 | 3.7% |
| Other values (59) | 363854 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 470220 | |
| Uppercase Letter | 319291 | |
| Space Separator | 122149 | 12.8% |
| Other Punctuation | 39861 | 4.2% |
| Decimal Number | 57 | < 0.1% |
| Math Symbol | 16 | < 0.1% |
| Dash Punctuation | 8 | < 0.1% |
| Open Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 57938 | |
| L | 46723 | |
| S | 39039 | |
| R | 32611 | |
| I | 30948 | |
| T | 28855 | |
| B | 14013 | 4.4% |
| N | 13504 | 4.2% |
| E | 11531 | 3.6% |
| K | 10471 | 3.3% |
| Other values (16) | 33658 |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 73678 | |
| a | 68481 | |
| o | 54592 | |
| s | 47002 | |
| e | 42537 | |
| c | 35610 | |
| k | 35239 | |
| h | 23502 | 5.0% |
| w | 22294 | 4.7% |
| i | 16667 | 3.5% |
| Other values (15) | 50618 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 28 | |
| 0 | 11 | 19.3% |
| 3 | 5 | 8.8% |
| 5 | 3 | 5.3% |
| 9 | 3 | 5.3% |
| 8 | 3 | 5.3% |
| 7 | 3 | 5.3% |
| 1 | 1 | 1.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 33211 | |
| , | 4876 | 12.2% |
| & | 1729 | 4.3% |
| / | 29 | 0.1% |
| @ | 15 | < 0.1% |
| % | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 122149 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 16 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 8 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 789511 | |
| Common | 162092 | 17.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 73678 | 9.3% |
| a | 68481 | 8.7% |
| C | 57938 | 7.3% |
| o | 54592 | 6.9% |
| s | 47002 | 6.0% |
| L | 46723 | 5.9% |
| e | 42537 | 5.4% |
| S | 39039 | 4.9% |
| c | 35610 | 4.5% |
| k | 35239 | 4.5% |
| Other values (41) | 288672 |
Common
| Value | Count | Frequency (%) |
| 122149 | ||
| . | 33211 | 20.5% |
| , | 4876 | 3.0% |
| & | 1729 | 1.1% |
| / | 29 | < 0.1% |
| 2 | 28 | < 0.1% |
| + | 16 | < 0.1% |
| @ | 15 | < 0.1% |
| 0 | 11 | < 0.1% |
| - | 8 | < 0.1% |
| Other values (8) | 20 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 951603 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 122149 | 12.8% | |
| n | 73678 | 7.7% |
| a | 68481 | 7.2% |
| C | 57938 | 6.1% |
| o | 54592 | 5.7% |
| s | 47002 | 4.9% |
| L | 46723 | 4.9% |
| e | 42537 | 4.5% |
| S | 39039 | 4.1% |
| c | 35610 | 3.7% |
| Other values (59) | 363854 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 25 |
| Value | Count | Frequency (%) |
| True | 49822 | |
| False | 25 | 0.1% |
| Distinct | 3116 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 22 |
| Missing (%) | < 0.1% |
| Memory size | 3.2 MiB |
| 12/30/2015 | 91 |
|---|---|
| 06/27/2020 | 81 |
| 06/11/2020 | 80 |
| 06/20/2020 | 79 |
| 10/28/2020 | 74 |
| Other values (3111) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 498250 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 200 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 08/08/2015 |
|---|---|
| 2nd row | 10/12/2021 |
| 3rd row | 12/19/2023 |
| 4th row | 01/13/2015 |
| 5th row | 07/18/2015 |
Common Values
| Value | Count | Frequency (%) |
| 12/30/2015 | 91 | 0.2% |
| 06/27/2020 | 81 | 0.2% |
| 06/11/2020 | 80 | 0.2% |
| 06/20/2020 | 79 | 0.2% |
| 10/28/2020 | 74 | 0.1% |
| 06/09/2020 | 74 | 0.1% |
| 12/27/2018 | 74 | 0.1% |
| 06/13/2020 | 73 | 0.1% |
| 12/19/2015 | 72 | 0.1% |
| 12/05/2020 | 71 | 0.1% |
| Other values (3106) | 49056 |
Length
| Value | Count | Frequency (%) |
| 12/30/2015 | 91 | 0.2% |
| 06/27/2020 | 81 | 0.2% |
| 06/11/2020 | 80 | 0.2% |
| 06/20/2020 | 79 | 0.2% |
| 10/28/2020 | 74 | 0.1% |
| 06/09/2020 | 74 | 0.1% |
| 12/27/2018 | 74 | 0.1% |
| 06/13/2020 | 73 | 0.1% |
| 12/19/2015 | 72 | 0.1% |
| 12/05/2020 | 71 | 0.1% |
| Other values (3106) | 49056 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 112587 | |
| 2 | 109520 | |
| / | 99650 | |
| 1 | 79418 | |
| 8 | 15947 | 3.2% |
| 9 | 15604 | 3.1% |
| 3 | 15574 | 3.1% |
| 6 | 14906 | 3.0% |
| 7 | 14461 | 2.9% |
| 5 | 13195 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 398600 | |
| Other Punctuation | 99650 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 112587 | |
| 2 | 109520 | |
| 1 | 79418 | |
| 8 | 15947 | 4.0% |
| 9 | 15604 | 3.9% |
| 3 | 15574 | 3.9% |
| 6 | 14906 | 3.7% |
| 7 | 14461 | 3.6% |
| 5 | 13195 | 3.3% |
| 4 | 7388 | 1.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 99650 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 498250 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 112587 | |
| 2 | 109520 | |
| / | 99650 | |
| 1 | 79418 | |
| 8 | 15947 | 3.2% |
| 9 | 15604 | 3.1% |
| 3 | 15574 | 3.1% |
| 6 | 14906 | 3.0% |
| 7 | 14461 | 2.9% |
| 5 | 13195 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 498250 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 112587 | |
| 2 | 109520 | |
| / | 99650 | |
| 1 | 79418 | |
| 8 | 15947 | 3.2% |
| 9 | 15604 | 3.1% |
| 3 | 15574 | 3.1% |
| 6 | 14906 | 3.0% |
| 7 | 14461 | 2.9% |
| 5 | 13195 | 2.6% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 92 |
| Value | Count | Frequency (%) |
| True | 49755 | |
| False | 92 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 94 |
| Missing (%) | 0.2% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 152 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49753 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 49601 | |
| A | 152 | 0.3% |
| (Missing) | 94 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 49601 | |
| a | 152 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 49601 | |
| A | 152 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49753 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 49601 | |
| A | 152 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49753 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 49601 | |
| A | 152 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49753 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 49601 | |
| A | 152 | 0.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 56 |
| Value | Count | Frequency (%) |
| True | 49791 | |
| False | 56 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 58 |
| Missing (%) | 0.1% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 128 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49789 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 49661 | |
| A | 128 | 0.3% |
| (Missing) | 58 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 49661 | |
| a | 128 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 49661 | |
| A | 128 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49789 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 49661 | |
| A | 128 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49789 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 49661 | |
| A | 128 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49789 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 49661 | |
| A | 128 | 0.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 57 |
| Value | Count | Frequency (%) |
| True | 49790 | |
| False | 57 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 59 |
| Missing (%) | 0.1% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 81 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49788 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 49707 | |
| A | 81 | 0.2% |
| (Missing) | 59 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 49707 | |
| a | 81 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 49707 | |
| A | 81 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49788 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 49707 | |
| A | 81 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49788 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 49707 | |
| A | 81 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49788 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 49707 | |
| A | 81 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 104 |
| Value | Count | Frequency (%) |
| True | 49743 | |
| False | 104 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 106 |
| Missing (%) | 0.2% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 144 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49741 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 49597 | |
| A | 144 | 0.3% |
| (Missing) | 106 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 49597 | |
| a | 144 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 49597 | |
| A | 144 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49741 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 49597 | |
| A | 144 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49741 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 49597 | |
| A | 144 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49741 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 49597 | |
| A | 144 | 0.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 52 |
| Value | Count | Frequency (%) |
| True | 49795 | |
| False | 52 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 54 |
| Missing (%) | 0.1% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 123 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49793 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 49670 | |
| A | 123 | 0.2% |
| (Missing) | 54 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 49670 | |
| a | 123 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 49670 | |
| A | 123 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49793 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 49670 | |
| A | 123 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49793 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 49670 | |
| A | 123 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49793 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 49670 | |
| A | 123 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 124 |
| Value | Count | Frequency (%) |
| True | 49723 | |
| False | 124 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 126 |
| Missing (%) | 0.3% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 142 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49721 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 49579 | |
| A | 142 | 0.3% |
| (Missing) | 126 | 0.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 49579 | |
| a | 142 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 49579 | |
| A | 142 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49721 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 49579 | |
| A | 142 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49721 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 49579 | |
| A | 142 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49721 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 49579 | |
| A | 142 | 0.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 99 |
| Value | Count | Frequency (%) |
| True | 49748 | |
| False | 99 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 99 |
| Missing (%) | 0.2% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 950 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49748 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 48798 | |
| A | 950 | 1.9% |
| (Missing) | 99 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 48798 | |
| a | 950 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 48798 | |
| A | 950 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49748 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 48798 | |
| A | 950 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49748 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 48798 | |
| A | 950 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49748 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 48798 | |
| A | 950 | 1.9% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 100 |
| Value | Count | Frequency (%) |
| True | 49747 | |
| False | 100 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 100 |
| Missing (%) | 0.2% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 89 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49747 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 49658 | |
| A | 89 | 0.2% |
| (Missing) | 100 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 49658 | |
| a | 89 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 49658 | |
| A | 89 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49747 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 49658 | |
| A | 89 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49747 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 49658 | |
| A | 89 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49747 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 49658 | |
| A | 89 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 101 |
| Value | Count | Frequency (%) |
| True | 49746 | |
| False | 101 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 101 |
| Missing (%) | 0.2% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 213 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49746 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 49533 | |
| A | 213 | 0.4% |
| (Missing) | 101 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 49533 | |
| a | 213 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 49533 | |
| A | 213 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49746 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 49533 | |
| A | 213 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49746 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 49533 | |
| A | 213 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49746 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 49533 | |
| A | 213 | 0.4% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| True | |
|---|---|
| False | 62 |
| Value | Count | Frequency (%) |
| True | 49785 | |
| False | 62 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 62 |
| Missing (%) | 0.1% |
| Memory size | 2.8 MiB |
| N | |
|---|---|
| A | 42 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49785 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 49743 | |
| A | 42 | 0.1% |
| (Missing) | 62 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| n | 49743 | |
| a | 42 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 49743 | |
| A | 42 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49785 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 49743 | |
| A | 42 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49785 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 49743 | |
| A | 42 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49785 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 49743 | |
| A | 42 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 6 |
| Missing (%) | < 0.1% |
| Memory size | 97.5 KiB |
| True | |
|---|---|
| False | 107 |
| (Missing) | 6 |
| Value | Count | Frequency (%) |
| True | 49734 | |
| False | 107 | 0.2% |
| (Missing) | 6 | < 0.1% |
| Distinct | 738 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 116 |
| Missing (%) | 0.2% |
| Memory size | 3.5 MiB |
| EMSL | |
|---|---|
| ENVIRONMENTAL BUILDING SOLUTIONS LLC | |
| EMSL Analytical | |
| Environmental Building Solutions LLC | |
| EBS | |
| Other values (733) |
Length
| Max length | 94 |
|---|---|
| Median length | 93 |
| Mean length | 17.13478514 |
| Min length | 1 |
Characters and Unicode
| Total characters | 852130 |
|---|---|
| Distinct characters | 73 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 385 ? |
|---|---|
| Unique (%) | 0.8% |
Sample
| 1st row | ENVIRONMENTAL BUILDING SOLUTIONS LLC |
|---|---|
| 2nd row | EMSL |
| 3rd row | Atlas Enviornmental lab corp. |
| 4th row | ENVIRONMENTAL BUILDING SOLUTIONS LLC |
| 5th row | ESML |
Common Values
| Value | Count | Frequency (%) |
| EMSL | 16737 | |
| ENVIRONMENTAL BUILDING SOLUTIONS LLC | 7934 | |
| EMSL Analytical | 4309 | 8.6% |
| Environmental Building Solutions LLC | 3586 | 7.2% |
| EBS | 3061 | 6.1% |
| ESML | 1905 | 3.8% |
| ENVIRONMENTAL BUILDING SOLUTIONS, LLC | 1243 | 2.5% |
| ebs | 1232 | 2.5% |
| Environmental Building Solutions, LLC | 973 | 2.0% |
| Environmental Building | 636 | 1.3% |
| Other values (728) | 8115 |
Length
| Value | Count | Frequency (%) |
| emsl | 21600 | |
| environmental | 17394 | |
| building | 16185 | |
| solutions | 15511 | |
| llc | 14725 | |
| analytical | 4874 | 4.4% |
| ebs | 4301 | 3.9% |
| atlas | 2012 | 1.8% |
| esml | 1908 | 1.7% |
| lab | 1643 | 1.5% |
| Other values (347) | 11458 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 84486 | 9.9% |
| 61896 | 7.3% | |
| E | 55317 | 6.5% |
| S | 52118 | 6.1% |
| N | 50379 | 5.9% |
| n | 44880 | 5.3% |
| I | 40553 | 4.8% |
| i | 36529 | 4.3% |
| l | 34929 | 4.1% |
| M | 34367 | 4.0% |
| Other values (63) | 356676 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 484408 | |
| Lowercase Letter | 300116 | |
| Space Separator | 61896 | 7.3% |
| Other Punctuation | 4462 | 0.5% |
| Decimal Number | 1225 | 0.1% |
| Open Punctuation | 8 | < 0.1% |
| Close Punctuation | 8 | < 0.1% |
| Dash Punctuation | 7 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 84486 | |
| E | 55317 | |
| S | 52118 | |
| N | 50379 | |
| I | 40553 | |
| M | 34367 | |
| O | 29706 | 6.1% |
| T | 21013 | 4.3% |
| B | 19611 | 4.0% |
| A | 19443 | 4.0% |
| Other values (16) | 77415 |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 44880 | |
| i | 36529 | |
| l | 34929 | |
| o | 25298 | |
| t | 24954 | |
| a | 24564 | |
| e | 15972 | 5.3% |
| r | 13972 | 4.7% |
| u | 13946 | 4.6% |
| s | 10810 | 3.6% |
| Other values (15) | 54262 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 609 | |
| 8 | 231 | 18.9% |
| 7 | 190 | 15.5% |
| 0 | 92 | 7.5% |
| 6 | 45 | 3.7% |
| 5 | 17 | 1.4% |
| 4 | 17 | 1.4% |
| 9 | 12 | 1.0% |
| 2 | 10 | 0.8% |
| 3 | 2 | 0.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 3016 | |
| . | 1192 | 26.7% |
| # | 139 | 3.1% |
| / | 81 | 1.8% |
| ' | 15 | 0.3% |
| ; | 10 | 0.2% |
| : | 6 | 0.1% |
| & | 3 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 61896 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 8 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 8 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 7 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 784524 | |
| Common | 67606 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 84486 | 10.8% |
| E | 55317 | 7.1% |
| S | 52118 | 6.6% |
| N | 50379 | 6.4% |
| n | 44880 | 5.7% |
| I | 40553 | 5.2% |
| i | 36529 | 4.7% |
| l | 34929 | 4.5% |
| M | 34367 | 4.4% |
| O | 29706 | 3.8% |
| Other values (41) | 321260 |
Common
| Value | Count | Frequency (%) |
| 61896 | ||
| , | 3016 | 4.5% |
| . | 1192 | 1.8% |
| 1 | 609 | 0.9% |
| 8 | 231 | 0.3% |
| 7 | 190 | 0.3% |
| # | 139 | 0.2% |
| 0 | 92 | 0.1% |
| / | 81 | 0.1% |
| 6 | 45 | 0.1% |
| Other values (12) | 115 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 852130 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| L | 84486 | 9.9% |
| 61896 | 7.3% | |
| E | 55317 | 6.5% |
| S | 52118 | 6.1% |
| N | 50379 | 5.9% |
| n | 44880 | 5.3% |
| I | 40553 | 4.8% |
| i | 36529 | 4.3% |
| l | 34929 | 4.1% |
| M | 34367 | 4.0% |
| Other values (63) | 356676 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 114 |
| Missing (%) | 0.2% |
| Memory size | 2.8 MiB |
| Y | |
|---|---|
| D | 85 |
| N | 18 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49733 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Y |
|---|---|
| 2nd row | Y |
| 3rd row | Y |
| 4th row | Y |
| 5th row | Y |
Common Values
| Value | Count | Frequency (%) |
| Y | 49630 | |
| D | 85 | 0.2% |
| N | 18 | < 0.1% |
| (Missing) | 114 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| y | 49630 | |
| d | 85 | 0.2% |
| n | 18 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| Y | 49630 | |
| D | 85 | 0.2% |
| N | 18 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49733 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| Y | 49630 | |
| D | 85 | 0.2% |
| N | 18 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49733 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| Y | 49630 | |
| D | 85 | 0.2% |
| N | 18 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49733 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| Y | 49630 | |
| D | 85 | 0.2% |
| N | 18 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 109 |
| Missing (%) | 0.2% |
| Memory size | 2.8 MiB |
| B |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49738 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | B |
|---|---|
| 2nd row | B |
| 3rd row | B |
| 4th row | B |
| 5th row | B |
Common Values
| Value | Count | Frequency (%) |
| B | 49738 | |
| (Missing) | 109 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| b | 49738 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 49738 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49738 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 49738 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49738 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 49738 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49738 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 49738 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 135 |
| Missing (%) | 0.3% |
| Memory size | 2.8 MiB |
| A | |
|---|---|
| P | 15 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49712 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 49697 | |
| P | 15 | < 0.1% |
| (Missing) | 135 | 0.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| a | 49697 | |
| p | 15 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 49697 | |
| P | 15 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49712 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 49697 | |
| P | 15 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49712 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 49697 | |
| P | 15 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49712 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 49697 | |
| P | 15 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 135 |
| Missing (%) | 0.3% |
| Memory size | 2.8 MiB |
| A | |
|---|---|
| P | 18 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49712 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 49694 | |
| P | 18 | < 0.1% |
| (Missing) | 135 | 0.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| a | 49694 | |
| p | 18 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 49694 | |
| P | 18 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49712 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 49694 | |
| P | 18 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49712 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 49694 | |
| P | 18 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49712 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 49694 | |
| P | 18 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 38723 |
| Missing (%) | 77.7% |
| Memory size | 97.5 KiB |
| True | |
|---|---|
| False | 11 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 11113 | 22.3% |
| False | 11 | < 0.1% |
| (Missing) | 38723 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| False | |
|---|---|
| True | 51 |
| Value | Count | Frequency (%) |
| False | 49796 | |
| True | 51 | 0.1% |
| Distinct | 5524 |
|---|---|
| Distinct (%) | 11.1% |
| Missing | 95 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.75580716 |
| Minimum | 40.514811 |
|---|---|
| Maximum | 40.908632 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 40.514811 |
|---|---|
| 5-th percentile | 40.695426 |
| Q1 | 40.738851 |
| median | 40.756105 |
| Q3 | 40.77524 |
| 95-th percentile | 40.823477 |
| Maximum | 40.908632 |
| Range | 0.393821 |
| Interquartile range (IQR) | 0.036389 |
Descriptive statistics
| Standard deviation | 0.04147346128 |
|---|---|
| Coefficient of variation (CV) | 0.001017608635 |
| Kurtosis | 4.164851459 |
| Mean | 40.75580716 |
| Median Absolute Deviation (MAD) | 0.018157 |
| Skewness | -0.4370002353 |
| Sum | 2027682.918 |
| Variance | 0.00172004799 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.764149 | 115 | 0.2% |
| 40.703608 | 100 | 0.2% |
| 40.757004 | 90 | 0.2% |
| 40.768244 | 80 | 0.2% |
| 40.713001 | 79 | 0.2% |
| 40.748276 | 71 | 0.1% |
| 40.710536 | 70 | 0.1% |
| 40.707347 | 69 | 0.1% |
| 40.65576 | 59 | 0.1% |
| 40.754162 | 59 | 0.1% |
| Other values (5514) | 48960 | |
| (Missing) | 95 | 0.2% |
| Value | Count | Frequency (%) |
| 40.514811 | 28 | |
| 40.572169 | 7 | < 0.1% |
| 40.572765 | 6 | < 0.1% |
| 40.572833 | 9 | < 0.1% |
| 40.573621 | 8 | < 0.1% |
| 40.573698 | 20 | |
| 40.573838 | 6 | < 0.1% |
| 40.57448 | 9 | < 0.1% |
| 40.574792 | 7 | < 0.1% |
| 40.574842 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.908632 | 9 | |
| 40.907828 | 9 | |
| 40.906656 | 9 | |
| 40.905599 | 1 | < 0.1% |
| 40.904894 | 5 | |
| 40.904756 | 2 | < 0.1% |
| 40.904666 | 4 | |
| 40.903245 | 5 | |
| 40.900321 | 9 | |
| 40.898333 | 3 | < 0.1% |
| Distinct | 5456 |
|---|---|
| Distinct (%) | 11.0% |
| Missing | 95 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.96932981 |
| Minimum | -74.236572 |
|---|---|
| Maximum | -73.713493 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 49752 |
| Negative (%) | 99.8% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | -74.236572 |
|---|---|
| 5-th percentile | -74.008661 |
| Q1 | -73.98934 |
| median | -73.97791 |
| Q3 | -73.9618285 |
| 95-th percentile | -73.88164 |
| Maximum | -73.713493 |
| Range | 0.523079 |
| Interquartile range (IQR) | 0.0275115 |
Descriptive statistics
| Standard deviation | 0.03852047902 |
|---|---|
| Coefficient of variation (CV) | -0.0005207628503 |
| Kurtosis | 9.607390671 |
| Mean | -73.96932981 |
| Median Absolute Deviation (MAD) | 0.013229 |
| Skewness | 2.265310183 |
| Sum | -3680122.097 |
| Variance | 0.001483827304 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.955251 | 124 | 0.2% |
| -74.009691 | 100 | 0.2% |
| -74.010997 | 92 | 0.2% |
| -73.982526 | 90 | 0.2% |
| -73.982339 | 80 | 0.2% |
| -74.004181 | 79 | 0.2% |
| -74.009378 | 78 | 0.2% |
| -73.98469 | 71 | 0.1% |
| -73.983962 | 65 | 0.1% |
| -73.999235 | 61 | 0.1% |
| Other values (5446) | 48912 | |
| (Missing) | 95 | 0.2% |
| Value | Count | Frequency (%) |
| -74.236572 | 28 | |
| -74.171256 | 6 | < 0.1% |
| -74.171244 | 6 | < 0.1% |
| -74.092492 | 9 | < 0.1% |
| -74.080729 | 7 | < 0.1% |
| -74.076584 | 8 | < 0.1% |
| -74.073261 | 10 | < 0.1% |
| -74.06448 | 2 | < 0.1% |
| -74.040648 | 8 | < 0.1% |
| -74.037377 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| -73.713493 | 48 | |
| -73.713627 | 2 | < 0.1% |
| -73.742187 | 5 | < 0.1% |
| -73.75121 | 7 | < 0.1% |
| -73.751235 | 2 | < 0.1% |
| -73.753179 | 6 | < 0.1% |
| -73.753204 | 9 | < 0.1% |
| -73.753454 | 8 | < 0.1% |
| -73.759283 | 9 | < 0.1% |
| -73.76903 | 8 | < 0.1% |
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 95 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.771124779 |
| Minimum | 1 |
|---|---|
| Maximum | 81 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 6 |
| Q3 | 8 |
| 95-th percentile | 11 |
| Maximum | 81 |
| Range | 80 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 3.17385907 |
|---|---|
| Coefficient of variation (CV) | 0.5499550247 |
| Kurtosis | 131.7677664 |
| Mean | 5.771124779 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.937725023 |
| Sum | 287125 |
| Variance | 10.0733814 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 12069 | |
| 8 | 8255 | |
| 6 | 6034 | |
| 7 | 5857 | |
| 1 | 4297 | 8.6% |
| 2 | 3950 | 7.9% |
| 4 | 3316 | 6.7% |
| 9 | 1541 | 3.1% |
| 3 | 1115 | 2.2% |
| 11 | 1006 | 2.0% |
| Other values (10) | 2312 | 4.6% |
| Value | Count | Frequency (%) |
| 1 | 4297 | 8.6% |
| 2 | 3950 | 7.9% |
| 3 | 1115 | 2.2% |
| 4 | 3316 | 6.7% |
| 5 | 12069 | |
| 6 | 6034 | |
| 7 | 5857 | |
| 8 | 8255 | |
| 9 | 1541 | 3.1% |
| 10 | 621 | 1.2% |
| Value | Count | Frequency (%) |
| 81 | 20 | < 0.1% |
| 55 | 5 | < 0.1% |
| 18 | 8 | < 0.1% |
| 17 | 28 | 0.1% |
| 16 | 171 | 0.3% |
| 15 | 33 | 0.1% |
| 14 | 162 | 0.3% |
| 13 | 404 | |
| 12 | 860 | |
| 11 | 1006 |
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 95 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.222965911 |
| Minimum | 1 |
|---|---|
| Maximum | 51 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 33 |
| Maximum | 51 |
| Range | 50 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 9.276344355 |
|---|---|
| Coefficient of variation (CV) | 1.284284665 |
| Kurtosis | 6.228750238 |
| Mean | 7.222965911 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.625757536 |
| Sum | 359357 |
| Variance | 86.05056459 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 14895 | |
| 3 | 7215 | |
| 1 | 4968 | 10.0% |
| 6 | 4927 | 9.9% |
| 2 | 4106 | 8.2% |
| 5 | 3541 | 7.1% |
| 7 | 1314 | 2.6% |
| 33 | 1126 | 2.3% |
| 8 | 641 | 1.3% |
| 9 | 615 | 1.2% |
| Other values (39) | 6404 |
| Value | Count | Frequency (%) |
| 1 | 4968 | 10.0% |
| 2 | 4106 | 8.2% |
| 3 | 7215 | |
| 4 | 14895 | |
| 5 | 3541 | 7.1% |
| 6 | 4927 | 9.9% |
| 7 | 1314 | 2.6% |
| 8 | 641 | 1.3% |
| 9 | 615 | 1.2% |
| 10 | 446 | 0.9% |
| Value | Count | Frequency (%) |
| 51 | 28 | 0.1% |
| 49 | 48 | 0.1% |
| 48 | 178 | |
| 47 | 190 | |
| 45 | 22 | < 0.1% |
| 44 | 33 | 0.1% |
| 43 | 77 | |
| 42 | 129 | |
| 41 | 147 | |
| 40 | 120 |
| Distinct | 516 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 95 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3248.012341 |
| Minimum | 1 |
|---|---|
| Maximum | 155101 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 78 |
| median | 122 |
| Q3 | 195 |
| 95-th percentile | 16001 |
| Maximum | 155101 |
| Range | 155100 |
| Interquartile range (IQR) | 117 |
Descriptive statistics
| Standard deviation | 11467.20125 |
|---|---|
| Coefficient of variation (CV) | 3.530528843 |
| Kurtosis | 57.31772678 |
| Mean | 3248.012341 |
| Median Absolute Deviation (MAD) | 53 |
| Skewness | 6.573333742 |
| Sum | 161595110 |
| Variance | 131496704.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 812 | 1.6% |
| 96 | 734 | 1.5% |
| 113 | 695 | 1.4% |
| 137 | 691 | 1.4% |
| 82 | 644 | 1.3% |
| 13 | 609 | 1.2% |
| 7 | 605 | 1.2% |
| 102 | 592 | 1.2% |
| 109 | 573 | 1.1% |
| 74 | 565 | 1.1% |
| Other values (506) | 43232 |
| Value | Count | Frequency (%) |
| 1 | 182 | 0.4% |
| 3 | 18 | < 0.1% |
| 6 | 51 | 0.1% |
| 7 | 605 | |
| 8 | 108 | 0.2% |
| 9 | 812 | |
| 11 | 153 | 0.3% |
| 12 | 48 | 0.1% |
| 13 | 609 | |
| 15 | 145 | 0.3% |
| Value | Count | Frequency (%) |
| 155101 | 50 | |
| 122702 | 7 | < 0.1% |
| 122701 | 17 | < 0.1% |
| 103202 | 2 | < 0.1% |
| 101002 | 5 | < 0.1% |
| 101001 | 13 | < 0.1% |
| 99802 | 17 | < 0.1% |
| 99704 | 22 | |
| 99703 | 10 | < 0.1% |
| 97203 | 32 |
| Distinct | 5235 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 122 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1300742793 |
| Minimum | 0 |
|---|---|
| Maximum | 5080340045 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1000800004 |
| Q1 | 1008410018 |
| median | 1012600001 |
| Q3 | 1015180001 |
| 95-th percentile | 3061207501 |
| Maximum | 5080340045 |
| Range | 5080340045 |
| Interquartile range (IQR) | 6769983 |
Descriptive statistics
| Standard deviation | 766522392.2 |
|---|---|
| Coefficient of variation (CV) | 0.5892958978 |
| Kurtosis | 5.862141005 |
| Mean | 1300742793 |
| Median Absolute Deviation (MAD) | 3889933 |
| Skewness | 2.636551971 |
| Sum | 6.467943539 × 1013 |
| Variance | 5.875565777 × 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1014800001 | 124 | 0.2% |
| 1000327501 | 100 | 0.2% |
| 1000580001 | 99 | 0.2% |
| 1012617501 | 90 | 0.2% |
| 1007210007 | 89 | 0.2% |
| 1016040006 | 89 | 0.2% |
| 1010497501 | 80 | 0.2% |
| 1001210001 | 79 | 0.2% |
| 1002530001 | 77 | 0.2% |
| 1008350041 | 71 | 0.1% |
| Other values (5225) | 48827 | |
| (Missing) | 122 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1000047501 | 32 | |
| 1000050010 | 16 | |
| 1000057501 | 22 | |
| 1000087501 | 4 | < 0.1% |
| 1000090001 | 9 | < 0.1% |
| 1000090014 | 19 | |
| 1000090029 | 30 | |
| 1000100014 | 9 | < 0.1% |
| 1000100016 | 21 |
| Value | Count | Frequency (%) |
| 5080340045 | 28 | |
| 5028297501 | 2 | < 0.1% |
| 5012720011 | 12 | |
| 5005900001 | 9 | < 0.1% |
| 5000130008 | 7 | < 0.1% |
| 5000020015 | 8 | < 0.1% |
| 5000017501 | 10 | < 0.1% |
| 4161770055 | 9 | < 0.1% |
| 4161770035 | 8 | < 0.1% |
| 4161770001 | 9 | < 0.1% |
| Distinct | 147 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 95 |
| Missing (%) | 0.2% |
| Memory size | 3.8 MiB |
| Midtown-Midtown South | |
|---|---|
| Upper East Side-Carnegie Hill | |
| Hudson Yards-Chelsea-Flatiron-Union Square | |
| Turtle Bay-East Midtown | |
| Upper West Side | |
| Other values (142) |
Length
| Max length | 53 |
|---|---|
| Median length | 42 |
| Mean length | 22.87288953 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1137972 |
|---|---|
| Distinct characters | 55 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Turtle Bay-East Midtown |
|---|---|
| 2nd row | Upper East Side-Carnegie Hill |
| 3rd row | East Concourse-Concourse Village |
| 4th row | West Village |
| 5th row | Hunters Point-Sunnyside-West Maspeth |
Common Values
| Value | Count | Frequency (%) |
| Midtown-Midtown South | 8275 | |
| Upper East Side-Carnegie Hill | 4392 | 8.8% |
| Hudson Yards-Chelsea-Flatiron-Union Square | 3840 | 7.7% |
| Turtle Bay-East Midtown | 3550 | 7.1% |
| Upper West Side | 3546 | 7.1% |
| Battery Park City-Lower Manhattan | 2747 | 5.5% |
| Murray Hill-Kips Bay | 2270 | 4.6% |
| Lenox Hill-Roosevelt Island | 1857 | 3.7% |
| Lincoln Square | 1820 | 3.7% |
| West Village | 1730 | 3.5% |
| Other values (137) | 15725 |
Length
| Value | Count | Frequency (%) |
| south | 9288 | 7.1% |
| midtown-midtown | 8275 | 6.3% |
| upper | 7938 | 6.1% |
| east | 6118 | 4.7% |
| square | 5701 | 4.4% |
| hill | 5580 | 4.3% |
| west | 5531 | 4.2% |
| side-carnegie | 4392 | 3.4% |
| side | 3882 | 3.0% |
| hudson | 3840 | 2.9% |
| Other values (198) | 70297 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 86130 | 7.6% |
| e | 85913 | 7.5% |
| 81090 | 7.1% | |
| i | 79095 | 7.0% |
| o | 71818 | 6.3% |
| a | 71225 | 6.3% |
| n | 70588 | 6.2% |
| r | 61925 | 5.4% |
| l | 57316 | 5.0% |
| - | 45437 | 4.0% |
| Other values (45) | 427435 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 829339 | |
| Uppercase Letter | 182029 | 16.0% |
| Space Separator | 81090 | 7.1% |
| Dash Punctuation | 45437 | 4.0% |
| Other Punctuation | 69 | < 0.1% |
| Open Punctuation | 4 | < 0.1% |
| Close Punctuation | 4 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 86130 | |
| e | 85913 | |
| i | 79095 | |
| o | 71818 | |
| a | 71225 | |
| n | 70588 | |
| r | 61925 | 7.5% |
| l | 57316 | 6.9% |
| s | 43032 | 5.2% |
| d | 42315 | 5.1% |
| Other values (15) | 159982 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 27699 | |
| S | 26155 | |
| H | 20604 | |
| C | 19287 | |
| B | 13180 | |
| U | 12377 | 6.8% |
| E | 9860 | 5.4% |
| L | 8149 | 4.5% |
| W | 6690 | 3.7% |
| T | 5201 | 2.9% |
| Other values (14) | 32827 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 57 | |
| ' | 12 | 17.4% |
Space Separator
| Value | Count | Frequency (%) |
| 81090 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 45437 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 4 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1011368 | |
| Common | 126604 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 86130 | 8.5% |
| e | 85913 | 8.5% |
| i | 79095 | 7.8% |
| o | 71818 | 7.1% |
| a | 71225 | 7.0% |
| n | 70588 | 7.0% |
| r | 61925 | 6.1% |
| l | 57316 | 5.7% |
| s | 43032 | 4.3% |
| d | 42315 | 4.2% |
| Other values (39) | 342011 |
Common
| Value | Count | Frequency (%) |
| 81090 | ||
| - | 45437 | |
| . | 57 | < 0.1% |
| ' | 12 | < 0.1% |
| ( | 4 | < 0.1% |
| ) | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1137972 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 86130 | 7.6% |
| e | 85913 | 7.5% |
| 81090 | 7.1% | |
| i | 79095 | 7.0% |
| o | 71818 | 6.3% |
| a | 71225 | 6.3% |
| n | 70588 | 6.2% |
| r | 61925 | 5.4% |
| l | 57316 | 5.0% |
| - | 45437 | 4.0% |
| Other values (45) | 427435 |
| Distinct | 34 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.8 MiB |
| 04/19/2024 12:15:07 PM | 1638 |
|---|---|
| 04/19/2024 12:15:11 PM | 1512 |
| 04/19/2024 12:15:22 PM | 1512 |
| 04/19/2024 12:15:39 PM | 1510 |
| 04/19/2024 12:15:17 PM | 1509 |
| Other values (29) |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Characters and Unicode
| Total characters | 1096634 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 04/19/2024 12:15:09 PM |
|---|---|
| 2nd row | 04/19/2024 12:15:37 PM |
| 3rd row | 04/19/2024 12:15:40 PM |
| 4th row | 04/19/2024 12:15:09 PM |
| 5th row | 04/19/2024 12:15:07 PM |
Common Values
| Value | Count | Frequency (%) |
| 04/19/2024 12:15:07 PM | 1638 | 3.3% |
| 04/19/2024 12:15:11 PM | 1512 | 3.0% |
| 04/19/2024 12:15:22 PM | 1512 | 3.0% |
| 04/19/2024 12:15:39 PM | 1510 | 3.0% |
| 04/19/2024 12:15:17 PM | 1509 | 3.0% |
| 04/19/2024 12:15:24 PM | 1509 | 3.0% |
| 04/19/2024 12:15:35 PM | 1509 | 3.0% |
| 04/19/2024 12:15:21 PM | 1507 | 3.0% |
| 04/19/2024 12:15:31 PM | 1507 | 3.0% |
| 04/19/2024 12:15:32 PM | 1505 | 3.0% |
| Other values (24) | 34629 |
Length
| Value | Count | Frequency (%) |
| 04/19/2024 | 49847 | |
| pm | 49847 | |
| 12:15:07 | 1638 | 1.1% |
| 12:15:11 | 1512 | 1.0% |
| 12:15:22 | 1512 | 1.0% |
| 12:15:39 | 1510 | 1.0% |
| 12:15:17 | 1509 | 1.0% |
| 12:15:24 | 1509 | 1.0% |
| 12:15:35 | 1509 | 1.0% |
| 12:15:31 | 1507 | 1.0% |
| Other values (26) | 37641 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 168904 | |
| 2 | 168821 | |
| 0 | 109421 | |
| 4 | 104909 | |
| / | 99694 | |
| 99694 | ||
| : | 99694 | |
| 9 | 55815 | 5.1% |
| 5 | 54359 | 5.0% |
| P | 49847 | 4.5% |
| Other values (5) | 85476 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 697858 | |
| Other Punctuation | 199388 | 18.2% |
| Space Separator | 99694 | 9.1% |
| Uppercase Letter | 99694 | 9.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 168904 | |
| 2 | 168821 | |
| 0 | 109421 | |
| 4 | 104909 | |
| 9 | 55815 | 8.0% |
| 5 | 54359 | 7.8% |
| 3 | 19128 | 2.7% |
| 7 | 6052 | 0.9% |
| 8 | 5999 | 0.9% |
| 6 | 4450 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 99694 | |
| : | 99694 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 49847 | |
| M | 49847 |
Space Separator
| Value | Count | Frequency (%) |
| 99694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 996940 | |
| Latin | 99694 | 9.1% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 168904 | |
| 2 | 168821 | |
| 0 | 109421 | |
| 4 | 104909 | |
| / | 99694 | |
| 99694 | ||
| : | 99694 | |
| 9 | 55815 | 5.6% |
| 5 | 54359 | 5.5% |
| 3 | 19128 | 1.9% |
| Other values (3) | 16501 | 1.7% |
Latin
| Value | Count | Frequency (%) |
| P | 49847 | |
| M | 49847 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1096634 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 168904 | |
| 2 | 168821 | |
| 0 | 109421 | |
| 4 | 104909 | |
| / | 99694 | |
| 99694 | ||
| : | 99694 | |
| 9 | 55815 | 5.1% |
| 5 | 54359 | 5.0% |
| P | 49847 | 4.5% |
| Other values (5) | 85476 |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| BIN | BOROUGH | ZIP | HOUSE_NUM | STREET_NAME | BLOCK | LOT | CONFIRMATION_NUM | REPORTING_YEAR | TANK_NUM | INSPECTION_BY_FIRM | INSPECTION_PERFORMED | INSPECTION_DATE | GI_REQ_INTERNAL_STRUCTURE | GI_RESULT_INTERNAL_STRUCTURE | GI_REQ_EXTERNAL_STRUCTURE | GI_RESULT_EXTERNAL_STRUCTURE | GI_REQ_OVERFLOW_PIPES | GI_RESULT_OVERFLOW_PIPES | GI_REQ_ACCESS_LADDERS | GI_RESULT_ACCESS_LADDERS | GI_REQ_AIR_VENTS | GI_RESULT_AIR_VENTS | GI_REQ_ROOF_ACCESS | GI_RESULT_ROOF_ACCESS | SI_REQ_SEDIMENT | SI_RESULT_SEDIMENT | SI_REQ_BIOLOGICAL_GROWTH | SI_RESULT_BIOLOGICAL_GROWTH | SI_REQ_DEBRIS_INSECTS | SI_RESULT_DEBRIS_INSECTS | SI_REQ_RODENT_BIRD | SI_RESULT_RODENT_BIRD | SAMPLE_COLLECTED | LAB_NAME | NYS_CERTIFIED | ANALYTES | COLIFORM | ECOLI | MEET_STANDARDS | DELETED | LATITUDE | LONGITUDE | COMMUNITY_BOARD | COUNCIL_DISTRICT | CENSUS_TRACT | BBL | NTA | BATCH_DATE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1036156.0 | MANHATTAN | 10174.0 | 405 | LEXINGTON AVE | 1297 | 23 | WTI0794137521 | 2015 | 2 | ISSEKS BROS INC | Y | 08/08/2015 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | ENVIRONMENTAL BUILDING SOLUTIONS LLC | Y | B | A | A | NaN | No | 40.751823 | -73.975760 | 6.0 | 4.0 | 92.0 | 1.012970e+09 | Turtle Bay-East Midtown | 04/19/2024 12:15:09 PM |
| 1 | 1042461.0 | MANHATTAN | 10065.0 | 131 | East 66th Street | 1401 | 20 | WTI9605598636 | 2021 | 1 | Rosenwach Tank Co. LLC | Y | 10/12/2021 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | EMSL | Y | B | A | A | NaN | No | 40.766513 | -73.964748 | 8.0 | 4.0 | 120.0 | 1.014010e+09 | Upper East Side-Carnegie Hill | 04/19/2024 12:15:37 PM |
| 2 | 2101266.0 | BRONX | 10456.0 | 1118 | grand concourse | 2462 | 39 | WTI2761355464 | 2023 | 1 | DCAS | Y | 12/19/2023 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | Atlas Enviornmental lab corp. | Y | B | A | A | NaN | No | 40.832232 | -73.919655 | 4.0 | 16.0 | 18102.0 | 2.024620e+09 | East Concourse-Concourse Village | 04/19/2024 12:15:40 PM |
| 3 | 1009095.0 | MANHATTAN | 10003.0 | 28 | EAST 10 STREET | 561 | 7502 | WTI5921313699 | 2015 | 1 | ISSEKS BROS INC | Y | 01/13/2015 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | ENVIRONMENTAL BUILDING SOLUTIONS LLC | Y | B | A | A | NaN | No | 40.732489 | -73.993260 | 2.0 | 2.0 | 59.0 | 1.005618e+09 | West Village | 04/19/2024 12:15:09 PM |
| 4 | 4003540.0 | QUEENS | 11101.0 | 30-30 | 47th Avenue | 282 | 1 | WTI5300059568 | 2015 | 1 | Rosenwach Tank Co. LLC | Y | 07/18/2015 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | ESML | Y | B | A | A | NaN | No | 40.743168 | -73.936568 | 2.0 | 26.0 | 199.0 | 4.002820e+09 | Hunters Point-Sunnyside-West Maspeth | 04/19/2024 12:15:07 PM |
| 5 | 1045818.0 | MANHATTAN | 10021.0 | 435 | EAST 70 STREET | 1465 | 21 | WTI6238046041 | 2018 | 4 | Rosenwach Tank Co. LLC | Y | 08/16/2018 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | EMSL | Y | B | A | A | Y | No | 40.766129 | -73.956066 | 8.0 | 5.0 | 124.0 | 1.014650e+09 | Lenox Hill-Roosevelt Island | 04/19/2024 12:15:23 PM |
| 6 | 1030972.0 | MANHATTAN | 10023.0 | 344 | WEST 72 STREET | 1183 | 53 | WTI6814067879 | 2021 | 1 | ISSEKS BROS INC | Y | 10/12/2021 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | ENVIRONMENTAL BUILDING SOLUTIONS LLC | Y | B | A | A | NaN | No | 40.780406 | -73.985940 | 7.0 | 6.0 | 159.0 | 1.011830e+09 | Lincoln Square | 04/19/2024 12:15:36 PM |
| 7 | 4534604.0 | QUEENS | 11109.0 | 4705 | Center Blvd | 21 | 60 | WTI8421978672 | 2018 | 1 | Rockrose Development | Y | 11/12/2018 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | Pace Analytical | Y | B | A | A | Y | No | 40.745961 | -73.956823 | 2.0 | 26.0 | 1.0 | 4.000210e+09 | Hunters Point-Sunnyside-West Maspeth | 04/19/2024 12:15:17 PM |
| 8 | 1079000.0 | MANHATTAN | 10013.0 | 100 | Centre street | 167 | 1 | WTI9798191876 | 2021 | 2 | DCAS | Y | 12/05/2021 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | N | NaN | NaN | NaN | NaN | NaN | NaN | No | 40.716084 | -74.001425 | 1.0 | 1.0 | 29.0 | 1.001670e+09 | Chinatown | 04/19/2024 12:15:34 PM |
| 9 | 1036079.0 | MANHATTAN | 10022.0 | 745 | Fifth Ave | 1293 | 69 | WTI4076546871 | 2016 | 2 | Isseks Bros. Inc. | Y | 09/17/2016 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | Environmental Building Solutions LLC | Y | B | A | A | NaN | No | 40.763326 | -73.973695 | 5.0 | 4.0 | 11202.0 | 1.012930e+09 | Midtown-Midtown South | 04/19/2024 12:15:10 PM |
Last rows
| BIN | BOROUGH | ZIP | HOUSE_NUM | STREET_NAME | BLOCK | LOT | CONFIRMATION_NUM | REPORTING_YEAR | TANK_NUM | INSPECTION_BY_FIRM | INSPECTION_PERFORMED | INSPECTION_DATE | GI_REQ_INTERNAL_STRUCTURE | GI_RESULT_INTERNAL_STRUCTURE | GI_REQ_EXTERNAL_STRUCTURE | GI_RESULT_EXTERNAL_STRUCTURE | GI_REQ_OVERFLOW_PIPES | GI_RESULT_OVERFLOW_PIPES | GI_REQ_ACCESS_LADDERS | GI_RESULT_ACCESS_LADDERS | GI_REQ_AIR_VENTS | GI_RESULT_AIR_VENTS | GI_REQ_ROOF_ACCESS | GI_RESULT_ROOF_ACCESS | SI_REQ_SEDIMENT | SI_RESULT_SEDIMENT | SI_REQ_BIOLOGICAL_GROWTH | SI_RESULT_BIOLOGICAL_GROWTH | SI_REQ_DEBRIS_INSECTS | SI_RESULT_DEBRIS_INSECTS | SI_REQ_RODENT_BIRD | SI_RESULT_RODENT_BIRD | SAMPLE_COLLECTED | LAB_NAME | NYS_CERTIFIED | ANALYTES | COLIFORM | ECOLI | MEET_STANDARDS | DELETED | LATITUDE | LONGITUDE | COMMUNITY_BOARD | COUNCIL_DISTRICT | CENSUS_TRACT | BBL | NTA | BATCH_DATE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49837 | 1039577.0 | MANHATTAN | 10022.0 | 926 | 2 AVENUE | 1342 | 7502 | WTI8256422799 | 2015 | 1 | ISSEKS BROS INC | Y | 10/07/2015 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | ENVIRONMENTAL BUILDING SOLUTIONS LLC | Y | B | A | A | NaN | No | 40.754391 | -73.968865 | 6.0 | 4.0 | 98.0 | 1.013428e+09 | Turtle Bay-East Midtown | 04/19/2024 12:15:11 PM |
| 49838 | 1050288.0 | MANHATTAN | 10128.0 | 345 | EAST 93 STREET | 1556 | 23 | WTI6547790034 | 2019 | 1 | Rosenwach Tank Co. LLC | Y | 08/13/2019 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | EMSL | Y | B | A | A | Y | No | 40.781501 | -73.946545 | 8.0 | 5.0 | 154.0 | 1.015560e+09 | Yorkville | 04/19/2024 12:15:19 PM |
| 49839 | 1013561.0 | MANHATTAN | 10001.0 | 481 | 8th Avenue | 758 | 37 | WTI9666566390 | 2015 | 4 | NALCO | Y | 12/16/2015 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | A | Y | N | Y | N | Y | N | Y | Environmental Building Solutions | Y | B | A | A | NaN | No | 40.752295 | -73.993402 | 4.0 | 3.0 | 111.0 | 1.007580e+09 | Hudson Yards-Chelsea-Flatiron-Union Square | 04/19/2024 12:15:08 PM |
| 49840 | 1023161.0 | MANHATTAN | 10019.0 | 1301 | Sixth Avenue | 1005 | 29 | WTI7141946796 | 2021 | 1 | Rosenwach Tank Co. LLC | Y | 05/21/2021 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | EMSL | Y | B | A | A | NaN | No | 40.761244 | -73.979457 | 5.0 | 4.0 | 131.0 | 1.010050e+09 | Midtown-Midtown South | 04/19/2024 12:15:20 PM |
| 49841 | 1038755.0 | MANHATTAN | 10017.0 | 307 | EAST 44TH STREET | 1337 | 6 | WTI6051431041 | 2024 | 1 | ISSEKS BROS., INC. | Y | 01/10/2024 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | ENVIRONMENTAL BUILDING SOLUTIONS, LLC | Y | B | A | A | NaN | No | 40.750949 | -73.970841 | 6.0 | 4.0 | 90.0 | 1.013370e+09 | Turtle Bay-East Midtown | 04/19/2024 12:15:38 PM |
| 49842 | 1046609.0 | MANHATTAN | 10028.0 | 993 | Fifth Avenue | 1492 | 3 | WTI1912305134 | 2016 | 1 | Isseks Bros Inc | Y | 06/02/2016 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | Environmental Building Solutions LLC | Y | B | A | A | NaN | No | 40.777917 | -73.963041 | 8.0 | 4.0 | 142.0 | NaN | Upper East Side-Carnegie Hill | 04/19/2024 12:15:11 PM |
| 49843 | 1015240.0 | MANHATTAN | 10018.0 | 1359 | BROADWAY | 812 | 22 | WTI8209022370 | 2018 | 1 | Rosenwach Tank Co. LLC | Y | 03/24/2018 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | EMSL | Y | B | A | A | Y | No | 40.751704 | -73.987599 | 5.0 | 3.0 | 109.0 | 1.008120e+09 | Midtown-Midtown South | 04/19/2024 12:15:18 PM |
| 49844 | 1016080.0 | MANHATTAN | 10003.0 | 85 | 5 AVENUE | 844 | 1 | WTI2121287041 | 2019 | 1 | Rosenwach Tank Co. LLC | Y | 11/23/2019 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | EMSL Analytical | Y | B | A | A | Y | No | 40.737416 | -73.992581 | 5.0 | 2.0 | 52.0 | 1.008440e+09 | Hudson Yards-Chelsea-Flatiron-Union Square | 04/19/2024 12:15:25 PM |
| 49845 | 4433878.0 | QUEENS | 11375.0 | 70-25 | YELLOWSTONE BOULEVARD | 3236 | 35 | WTI0442120892 | 2017 | 1 | Rosenwach Tank Co. LLC | Y | 05/04/2017 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | EMSL | Y | B | A | A | Y | No | 40.722598 | -73.849816 | 6.0 | 29.0 | 711.0 | 4.032360e+09 | Forest Hills | 04/19/2024 12:15:09 PM |
| 49846 | 1040043.0 | MANHATTAN | 10022.0 | 339 | East 58th Street | 1351 | 17 | WTI1724049027 | 2015 | 1 | Rosenwach Tank Co. LLC | Y | 04/11/2015 | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | N | Y | ESML | Y | B | A | A | NaN | No | 40.759440 | -73.963488 | 6.0 | 5.0 | 108.0 | 1.013510e+09 | Turtle Bay-East Midtown | 04/19/2024 12:15:09 PM |